
CREATE EXTERNAL TABLE jms_dm.dm_mng_customer_daliy_customer_summary_dt
(
    project_name             string COMMENT '项目名称',
    code                     string COMMENT '客户code',
    name                     string COMMENT '客户name',
    mall_id                  string COMMENT '商家id（主要对接第三方客户）',
    mall_name                string COMMENT '商家名称',
    customer_network_id      string COMMENT '客户所属网点id',
    customer_network_code    string COMMENT '客户所属网点code',
    customer_network_name    string COMMENT '客户所属网点name',
    date_time                string COMMENT '日期',
    waybill_total            int COMMENT '总订单量',
    cancel_num               int COMMENT '总取消量',
    need_taking_num          int COMMENT '应揽收量',
    actual_taking_num        int COMMENT '实际揽收量',
    no_taking_num            int COMMENT '有单未揽收量',
    lack_taking_num          int COMMENT '有单漏揽收量',
    transport_num            int COMMENT '运输中量',
    del_war_num              int COMMENT '派件中量',
    no_safe_num              int COMMENT '未妥投量',
    sign_num                 int COMMENT '已签收量',
    intercept_num            int COMMENT '拦截量',
    success_intercept_num    int COMMENT '成功拦截量',
    7d_update_intercept_num  int COMMENT '轨迹断更量',
    work_order_num           int COMMENT '客诉量',
    arbitration_num          int COMMENT '丢失量',
    express_num              int COMMENT '破损量',
    xj_sign                  int COMMENT '虚假签收量',
    sign_in_num              int COMMENT '时效内签收量',
    sign_out_num             int COMMENT '超时效签收量',
    nosign_in_num            int COMMENT '时效内未签收量',
    nosign_out_num           int COMMENT '超时效内未签收量',
    sign_rate                string COMMENT '时效达成率',
    on_taking_sum            int COMMENT '准点揽收量',
    have_taking_no_send_num  int COMMENT '有揽未发量',
    have_send_no_arrival_num int COMMENT '有发未到量'
)
    COMMENT '客户日报客户汇总'
    PARTITIONED BY ( dt STRING COMMENT '订单录入时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_mng_customer_daliy_customer_summary_dt'
;